CREATE TABLE [dbo].[VAT_Trans]
(
[REFERENCE_NUMBER] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_VAT_Trans_REFERENCE_NUMBER] DEFAULT (''),
[OVATRegNumber] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_VAT_Trans_OVATRegNumber] DEFAULT (''),
[OVATCountry] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_VAT_Trans_OVATCountry] DEFAULT (''),
[OVATBranchID] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_VAT_Trans_OVATBranchID] DEFAULT (''),
[OUseVATTaxation] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_VAT_Trans_OUseVATTaxation] DEFAULT (''),
[NTAX_AUTHOR_DEFAULT] [varchar] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_VAT_Trans_NTAX_AUTHOR_DEFAULT] DEFAULT (''),
[NVAT_REG_NUMBER] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_VAT_Trans_NVAT_REG_NUMBER] DEFAULT (''),
[NVAT_COUNTRY] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_VAT_Trans_NVAT_COUNTRY] DEFAULT (''),
[TYPE] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_VAT_Trans_TYPE] DEFAULT (''),
[CREDIT_SUFFIX] [tinyint] NOT NULL CONSTRAINT [DF_VAT_Trans_CREDIT_SUFFIX] DEFAULT ((0)),
[TaxOnShipTo] [bit] NOT NULL CONSTRAINT [DF_VAT_Trans_TaxOnShipTo] DEFAULT ((0)),
[IsVatTaxableOrder] [bit] NULL,
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[VAT_Trans] ADD CONSTRAINT [PK_VAT_Trans] PRIMARY KEY NONCLUSTERED ([TYPE], [REFERENCE_NUMBER]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[VAT_Trans] TO [IMIS]
GRANT SELECT ON  [dbo].[VAT_Trans] TO [IMIS]
GRANT INSERT ON  [dbo].[VAT_Trans] TO [IMIS]
GRANT DELETE ON  [dbo].[VAT_Trans] TO [IMIS]
GRANT UPDATE ON  [dbo].[VAT_Trans] TO [IMIS]
GO